using System;
using System.Collections.Generic;
using System.Text;
using AF_ORM.CORE;
using System.Data;
using System.Configuration;
using Bussiness.Config;     
using Bussiness.Entity;
namespace Bussiness.ManagerBase
{
                

     public abstract class PT_ToolInBillManagerBase
    {
        public PT_ToolInBillManagerBase()
        {
            Adapter.ConnectionString =  ConnectionConfig.ConnectionString;            
        }
                    
 
        /// <summary>
        /// Them moi du lieu
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity Insert(PT_ToolInBillEntity obj)
        { 
            return (PT_ToolInBillEntity) Adapter.Insert(obj);             
        }
 
 
        /// <summary>
        /// Update du lieu theo khoa chinh cua object
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity Update(PT_ToolInBillEntity obj)
        { 
            return (PT_ToolInBillEntity)Adapter.Update(obj);             
        }
 
 
        /// <summary>
        /// Update du lieu theo dieu kien trong object
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity UpdateWithCondition(PT_ToolInBillEntity obj,PT_ToolInBillEntity objCond)
        { 
            return (PT_ToolInBillEntity)Adapter.UpdateWithCondition(obj,objCond);             
        }
 
 
        public PT_ToolInBillEntity Delete(PT_ToolInBillEntity obj)
        { 
            return (PT_ToolInBillEntity)Adapter.Delete(obj);             
        }
 
 
        public PT_ToolInBillEntity DeleteWithCondition(PT_ToolInBillEntity objCond)
        { 
            return (PT_ToolInBillEntity)Adapter.DeleteWithCondition(objCond);             
        }
 


        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Amount duoc set trong object
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByAmount (PT_ToolInBillEntity obj)
        { 
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"Amount");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Amount 
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByAmount (double Amount )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.Amount = Amount;  
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"Amount");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien BillNo duoc set trong object
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByBillNo (PT_ToolInBillEntity obj)
        { 
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"BillNo");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien BillNo 
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByBillNo (string BillNo )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.BillNo = BillNo;  
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"BillNo");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Cost duoc set trong object
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByCost (PT_ToolInBillEntity obj)
        { 
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"Cost");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Cost 
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByCost (double Cost )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.Cost = Cost;  
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"Cost");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByCreatedBy (PT_ToolInBillEntity obj)
        { 
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"CreatedBy");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CreatedBy 
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByCreatedBy (string CreatedBy )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.CreatedBy = CreatedBy;  
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"CreatedBy");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByCreatedDate (PT_ToolInBillEntity obj)
        { 
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"CreatedDate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CreatedDate 
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByCreatedDate (DateTime CreatedDate )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.CreatedDate = CreatedDate;  
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"CreatedDate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien DiscountReason duoc set trong object
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByDiscountReason (PT_ToolInBillEntity obj)
        { 
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"DiscountReason");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien DiscountReason 
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByDiscountReason (string DiscountReason )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.DiscountReason = DiscountReason;  
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"DiscountReason");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Id duoc set trong object
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteById (PT_ToolInBillEntity obj)
        { 
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"Id");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Id 
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteById (int Id )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.Id = Id;  
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"Id");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien IsDeleted duoc set trong object
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByIsDeleted (PT_ToolInBillEntity obj)
        { 
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"IsDeleted");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien IsDeleted 
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByIsDeleted (bool IsDeleted )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.IsDeleted = IsDeleted;  
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"IsDeleted");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien IsOil duoc set trong object
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByIsOil (PT_ToolInBillEntity obj)
        { 
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"IsOil");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien IsOil 
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByIsOil (bool IsOil )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.IsOil = IsOil;  
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"IsOil");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien OriginalPrice duoc set trong object
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByOriginalPrice (PT_ToolInBillEntity obj)
        { 
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"OriginalPrice");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien OriginalPrice 
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByOriginalPrice (double OriginalPrice )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.OriginalPrice = OriginalPrice;  
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"OriginalPrice");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Part_Name duoc set trong object
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByPart_Name (PT_ToolInBillEntity obj)
        { 
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"Part_Name");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Part_Name 
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByPart_Name (string Part_Name )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.Part_Name = Part_Name;  
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"Part_Name");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Part_No duoc set trong object
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByPart_No (PT_ToolInBillEntity obj)
        { 
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"Part_No");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Part_No 
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByPart_No (string Part_No )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.Part_No = Part_No;  
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"Part_No");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Price_After_Discount duoc set trong object
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByPrice_After_Discount (PT_ToolInBillEntity obj)
        { 
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"Price_After_Discount");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Price_After_Discount 
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByPrice_After_Discount (double Price_After_Discount )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.Price_After_Discount = Price_After_Discount;  
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"Price_After_Discount");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien QTY duoc set trong object
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByQTY (PT_ToolInBillEntity obj)
        { 
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"QTY");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien QTY 
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByQTY (int QTY )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.QTY = QTY;  
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"QTY");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ServiceType duoc set trong object
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByServiceType (PT_ToolInBillEntity obj)
        { 
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"ServiceType");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ServiceType 
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByServiceType (string ServiceType )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.ServiceType = ServiceType;  
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"ServiceType");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ToolType duoc set trong object
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByToolType (PT_ToolInBillEntity obj)
        { 
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"ToolType");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ToolType 
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByToolType (int ToolType )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.ToolType = ToolType;  
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"ToolType");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByUpdatedBy (PT_ToolInBillEntity obj)
        { 
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"UpdatedBy");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien UpdatedBy 
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByUpdatedBy (string UpdatedBy )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.UpdatedBy = UpdatedBy;  
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"UpdatedBy");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByUpdatedDate (PT_ToolInBillEntity obj)
        { 
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"UpdatedDate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien UpdatedDate 
        /// </summary>
        /// <returns>PT_ToolInBillEntity</returns>
        public PT_ToolInBillEntity DeleteByUpdatedDate (DateTime UpdatedDate )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.UpdatedDate = UpdatedDate;  
            return (PT_ToolInBillEntity)Adapter.DeleteByField(obj,"UpdatedDate");
        }

 
        /// <summary>
        /// Lay du lieu theo khoa chinh object
        /// </summary>
        /// <returns></returns>
        public PT_ToolInBillEntity Select(PT_ToolInBillEntity obj)
        { 
            return (PT_ToolInBillEntity) Adapter.Select(obj);             
        }
 
 
        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns></returns>
        public DataTable SelectWithCondition(PT_ToolInBillEntity obj)
        { 
            return  Adapter.SelectWithCondition(obj);             
        }
 
 
        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns></returns>
        public DataTable SelectWithCondition(PT_ToolInBillEntity obj,SelectOptions option)
        {             
            return  Adapter.SelectWithCondition(obj,option);             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public DataTable SelectAll()
        { 
            return Adapter.SelectAll(new PT_ToolInBillEntity());             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public DataTable SelectAll(SelectOptions option)
        { 
            return Adapter.SelectAll(new PT_ToolInBillEntity(),option);             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public List<PT_ToolInBillEntity> SelectAllLST()
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectAll(new PT_ToolInBillEntity()),new PT_ToolInBillEntity());           
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public List<PT_ToolInBillEntity> SelectAllLST(SelectOptions option)
        { 
            return (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectAll(new PT_ToolInBillEntity(),option),new PT_ToolInBillEntity());             
        }
 

        /// <summary>
        /// Lay du lieu theo cac dieu kien Amount duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByAmount (PT_ToolInBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"Amount");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Amount duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByAmount (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Amount",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Amount duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByAmountLST (PT_ToolInBillEntity obj)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Amount"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Amount duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByAmountLST (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Amount",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Amount 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByAmount (double Amount )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.Amount = Amount;  
            return Adapter.SelectByField(obj,"Amount");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Amount duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByAmount (double Amount, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.Amount = Amount;  
            return Adapter.SelectByField(obj,"Amount",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Amount 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByAmountLST (double Amount )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.Amount = Amount;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Amount"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Amount duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByAmountLST (double Amount, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.Amount = Amount;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Amount",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BillNo duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBillNo (PT_ToolInBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"BillNo");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BillNo duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBillNo (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"BillNo",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BillNo duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByBillNoLST (PT_ToolInBillEntity obj)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"BillNo"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BillNo duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByBillNoLST (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"BillNo",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BillNo 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBillNo (string BillNo )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.BillNo = BillNo;  
            return Adapter.SelectByField(obj,"BillNo");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BillNo duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBillNo (string BillNo, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.BillNo = BillNo;  
            return Adapter.SelectByField(obj,"BillNo",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BillNo 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByBillNoLST (string BillNo )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.BillNo = BillNo;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"BillNo"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BillNo duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByBillNoLST (string BillNo, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.BillNo = BillNo;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"BillNo",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Cost duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCost (PT_ToolInBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"Cost");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Cost duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCost (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Cost",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Cost duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByCostLST (PT_ToolInBillEntity obj)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Cost"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Cost duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByCostLST (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Cost",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Cost 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCost (double Cost )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.Cost = Cost;  
            return Adapter.SelectByField(obj,"Cost");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Cost duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCost (double Cost, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.Cost = Cost;  
            return Adapter.SelectByField(obj,"Cost",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Cost 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByCostLST (double Cost )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.Cost = Cost;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Cost"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Cost duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByCostLST (double Cost, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.Cost = Cost;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Cost",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedBy (PT_ToolInBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"CreatedBy");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedBy (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CreatedBy",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByCreatedByLST (PT_ToolInBillEntity obj)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CreatedBy"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByCreatedByLST (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CreatedBy",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedBy (string CreatedBy )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.CreatedBy = CreatedBy;  
            return Adapter.SelectByField(obj,"CreatedBy");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedBy (string CreatedBy, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.CreatedBy = CreatedBy;  
            return Adapter.SelectByField(obj,"CreatedBy",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByCreatedByLST (string CreatedBy )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.CreatedBy = CreatedBy;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CreatedBy"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByCreatedByLST (string CreatedBy, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.CreatedBy = CreatedBy;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CreatedBy",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedDate (PT_ToolInBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"CreatedDate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedDate (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CreatedDate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByCreatedDateLST (PT_ToolInBillEntity obj)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CreatedDate"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByCreatedDateLST (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CreatedDate",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedDate (DateTime CreatedDate )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.CreatedDate = CreatedDate;  
            return Adapter.SelectByField(obj,"CreatedDate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedDate (DateTime CreatedDate, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.CreatedDate = CreatedDate;  
            return Adapter.SelectByField(obj,"CreatedDate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByCreatedDateLST (DateTime CreatedDate )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.CreatedDate = CreatedDate;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CreatedDate"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByCreatedDateLST (DateTime CreatedDate, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.CreatedDate = CreatedDate;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CreatedDate",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DiscountReason duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDiscountReason (PT_ToolInBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"DiscountReason");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DiscountReason duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDiscountReason (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"DiscountReason",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DiscountReason duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByDiscountReasonLST (PT_ToolInBillEntity obj)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DiscountReason"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DiscountReason duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByDiscountReasonLST (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"DiscountReason",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DiscountReason 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDiscountReason (string DiscountReason )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.DiscountReason = DiscountReason;  
            return Adapter.SelectByField(obj,"DiscountReason");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DiscountReason duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDiscountReason (string DiscountReason, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.DiscountReason = DiscountReason;  
            return Adapter.SelectByField(obj,"DiscountReason",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DiscountReason 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByDiscountReasonLST (string DiscountReason )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.DiscountReason = DiscountReason;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DiscountReason"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DiscountReason duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByDiscountReasonLST (string DiscountReason, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.DiscountReason = DiscountReason;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DiscountReason",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectById (PT_ToolInBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"Id");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectById (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Id",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByIdLST (PT_ToolInBillEntity obj)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Id"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByIdLST (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Id",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectById (int Id )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.Id = Id;  
            return Adapter.SelectByField(obj,"Id");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectById (int Id, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.Id = Id;  
            return Adapter.SelectByField(obj,"Id",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByIdLST (int Id )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.Id = Id;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Id"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByIdLST (int Id, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.Id = Id;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Id",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsDeleted (PT_ToolInBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"IsDeleted");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsDeleted (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"IsDeleted",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByIsDeletedLST (PT_ToolInBillEntity obj)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"IsDeleted"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByIsDeletedLST (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"IsDeleted",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsDeleted (bool IsDeleted )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.IsDeleted = IsDeleted;  
            return Adapter.SelectByField(obj,"IsDeleted");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsDeleted (bool IsDeleted, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.IsDeleted = IsDeleted;  
            return Adapter.SelectByField(obj,"IsDeleted",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByIsDeletedLST (bool IsDeleted )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.IsDeleted = IsDeleted;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"IsDeleted"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByIsDeletedLST (bool IsDeleted, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.IsDeleted = IsDeleted;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"IsDeleted",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsOil duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsOil (PT_ToolInBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"IsOil");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsOil duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsOil (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"IsOil",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsOil duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByIsOilLST (PT_ToolInBillEntity obj)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"IsOil"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsOil duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByIsOilLST (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"IsOil",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsOil 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsOil (bool IsOil )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.IsOil = IsOil;  
            return Adapter.SelectByField(obj,"IsOil");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsOil duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsOil (bool IsOil, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.IsOil = IsOil;  
            return Adapter.SelectByField(obj,"IsOil",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsOil 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByIsOilLST (bool IsOil )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.IsOil = IsOil;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"IsOil"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsOil duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByIsOilLST (bool IsOil, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.IsOil = IsOil;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"IsOil",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OriginalPrice duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByOriginalPrice (PT_ToolInBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"OriginalPrice");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OriginalPrice duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByOriginalPrice (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"OriginalPrice",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OriginalPrice duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByOriginalPriceLST (PT_ToolInBillEntity obj)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"OriginalPrice"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OriginalPrice duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByOriginalPriceLST (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"OriginalPrice",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OriginalPrice 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByOriginalPrice (double OriginalPrice )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.OriginalPrice = OriginalPrice;  
            return Adapter.SelectByField(obj,"OriginalPrice");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OriginalPrice duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByOriginalPrice (double OriginalPrice, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.OriginalPrice = OriginalPrice;  
            return Adapter.SelectByField(obj,"OriginalPrice",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OriginalPrice 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByOriginalPriceLST (double OriginalPrice )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.OriginalPrice = OriginalPrice;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"OriginalPrice"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OriginalPrice duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByOriginalPriceLST (double OriginalPrice, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.OriginalPrice = OriginalPrice;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"OriginalPrice",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Part_Name duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPart_Name (PT_ToolInBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"Part_Name");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Part_Name duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPart_Name (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Part_Name",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Part_Name duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByPart_NameLST (PT_ToolInBillEntity obj)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Part_Name"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Part_Name duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByPart_NameLST (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Part_Name",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Part_Name 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPart_Name (string Part_Name )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.Part_Name = Part_Name;  
            return Adapter.SelectByField(obj,"Part_Name");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Part_Name duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPart_Name (string Part_Name, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.Part_Name = Part_Name;  
            return Adapter.SelectByField(obj,"Part_Name",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Part_Name 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByPart_NameLST (string Part_Name )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.Part_Name = Part_Name;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Part_Name"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Part_Name duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByPart_NameLST (string Part_Name, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.Part_Name = Part_Name;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Part_Name",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Part_No duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPart_No (PT_ToolInBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"Part_No");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Part_No duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPart_No (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Part_No",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Part_No duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByPart_NoLST (PT_ToolInBillEntity obj)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Part_No"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Part_No duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByPart_NoLST (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Part_No",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Part_No 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPart_No (string Part_No )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.Part_No = Part_No;  
            return Adapter.SelectByField(obj,"Part_No");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Part_No duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPart_No (string Part_No, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.Part_No = Part_No;  
            return Adapter.SelectByField(obj,"Part_No",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Part_No 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByPart_NoLST (string Part_No )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.Part_No = Part_No;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Part_No"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Part_No duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByPart_NoLST (string Part_No, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.Part_No = Part_No;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Part_No",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Price_After_Discount duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPrice_After_Discount (PT_ToolInBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"Price_After_Discount");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Price_After_Discount duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPrice_After_Discount (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Price_After_Discount",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Price_After_Discount duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByPrice_After_DiscountLST (PT_ToolInBillEntity obj)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Price_After_Discount"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Price_After_Discount duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByPrice_After_DiscountLST (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Price_After_Discount",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Price_After_Discount 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPrice_After_Discount (double Price_After_Discount )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.Price_After_Discount = Price_After_Discount;  
            return Adapter.SelectByField(obj,"Price_After_Discount");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Price_After_Discount duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPrice_After_Discount (double Price_After_Discount, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.Price_After_Discount = Price_After_Discount;  
            return Adapter.SelectByField(obj,"Price_After_Discount",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Price_After_Discount 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByPrice_After_DiscountLST (double Price_After_Discount )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.Price_After_Discount = Price_After_Discount;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Price_After_Discount"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Price_After_Discount duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByPrice_After_DiscountLST (double Price_After_Discount, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.Price_After_Discount = Price_After_Discount;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Price_After_Discount",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByQTY (PT_ToolInBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"QTY");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByQTY (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"QTY",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByQTYLST (PT_ToolInBillEntity obj)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"QTY"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByQTYLST (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"QTY",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByQTY (int QTY )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.QTY = QTY;  
            return Adapter.SelectByField(obj,"QTY");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByQTY (int QTY, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.QTY = QTY;  
            return Adapter.SelectByField(obj,"QTY",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByQTYLST (int QTY )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.QTY = QTY;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"QTY"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByQTYLST (int QTY, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.QTY = QTY;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"QTY",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceType duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByServiceType (PT_ToolInBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"ServiceType");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceType duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByServiceType (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"ServiceType",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceType duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByServiceTypeLST (PT_ToolInBillEntity obj)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ServiceType"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceType duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByServiceTypeLST (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"ServiceType",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceType 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByServiceType (string ServiceType )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.ServiceType = ServiceType;  
            return Adapter.SelectByField(obj,"ServiceType");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceType duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByServiceType (string ServiceType, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.ServiceType = ServiceType;  
            return Adapter.SelectByField(obj,"ServiceType",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceType 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByServiceTypeLST (string ServiceType )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.ServiceType = ServiceType;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ServiceType"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceType duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByServiceTypeLST (string ServiceType, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.ServiceType = ServiceType;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ServiceType",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ToolType duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByToolType (PT_ToolInBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"ToolType");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ToolType duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByToolType (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"ToolType",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ToolType duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByToolTypeLST (PT_ToolInBillEntity obj)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ToolType"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ToolType duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByToolTypeLST (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"ToolType",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ToolType 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByToolType (int ToolType )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.ToolType = ToolType;  
            return Adapter.SelectByField(obj,"ToolType");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ToolType duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByToolType (int ToolType, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.ToolType = ToolType;  
            return Adapter.SelectByField(obj,"ToolType",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ToolType 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByToolTypeLST (int ToolType )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.ToolType = ToolType;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ToolType"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ToolType duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByToolTypeLST (int ToolType, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.ToolType = ToolType;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ToolType",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedBy (PT_ToolInBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"UpdatedBy");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedBy (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"UpdatedBy",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByUpdatedByLST (PT_ToolInBillEntity obj)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UpdatedBy"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByUpdatedByLST (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"UpdatedBy",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedBy (string UpdatedBy )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.UpdatedBy = UpdatedBy;  
            return Adapter.SelectByField(obj,"UpdatedBy");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedBy (string UpdatedBy, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.UpdatedBy = UpdatedBy;  
            return Adapter.SelectByField(obj,"UpdatedBy",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByUpdatedByLST (string UpdatedBy )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.UpdatedBy = UpdatedBy;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UpdatedBy"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByUpdatedByLST (string UpdatedBy, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.UpdatedBy = UpdatedBy;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UpdatedBy",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedDate (PT_ToolInBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"UpdatedDate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedDate (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"UpdatedDate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByUpdatedDateLST (PT_ToolInBillEntity obj)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UpdatedDate"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectByUpdatedDateLST (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"UpdatedDate",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedDate (DateTime UpdatedDate )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.UpdatedDate = UpdatedDate;  
            return Adapter.SelectByField(obj,"UpdatedDate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedDate (DateTime UpdatedDate, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.UpdatedDate = UpdatedDate;  
            return Adapter.SelectByField(obj,"UpdatedDate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByUpdatedDateLST (DateTime UpdatedDate )
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.UpdatedDate = UpdatedDate;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UpdatedDate"),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ToolInBillEntity> SelectByUpdatedDateLST (DateTime UpdatedDate, SelectOptions option)
        { 
            PT_ToolInBillEntity obj = new PT_ToolInBillEntity();
            obj.UpdatedDate = UpdatedDate;  
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UpdatedDate",option),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectWithConditionLST (PT_ToolInBillEntity obj)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectWithCondition(obj),new PT_ToolInBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns>List<PT_ToolInBillEntity></returns>
        public List<PT_ToolInBillEntity> SelectWithConditionLST (PT_ToolInBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ToolInBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectWithCondition(obj,option),new PT_ToolInBillEntity());
        }

}
}
